Read Cell
AutomatR.GoogleSheets.Activities.ReadCell
The "Read Cell" activity in AutomatR is part of the Google Sheets activities package, designed to read the value from a specified cell in a Google spreadsheet. This activity streamlines the process of retrieving cell values, enhancing the efficiency of automation workflows involving Google Sheets.
Properties
| Name | Description |
|---|---|
| Input | |
| Cell Address | Specifies the cell location on the spreadsheet to read (e.g., A1). String variables containing the cell address. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Read Cell" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Cell Value | Outputs the value or content of the specified cell. String variables to store the cell value. |
How to use:
- Drag and drop the "Read Cell" activity onto the workflow.
- Configure the properties by specifying the cell address on the spreadsheet to read and optional settings like Delay.
- Place the "Read Cell" activity within a "Google Sheets App Scope" to ensure proper authentication and access to the Google Sheets service.
- Execute the workflow to retrieve the value from the specified cell in the Google spreadsheet.
Example: Consider an example where the "Read Cell" activity is used to read the value from cell B2 in a Google Sheet named "Expense Sheet":
Read Cell:
Cell Address: "B2"
Delay: 1
Cell Value: cellContent
In this example, the activity reads the content of cell B2 in the "Expense Sheet" and stores the result in the string variable "cellContent" for further use in the workflow.